How to: Add a memo field in a table.
Solution:
In the Table Design view, insert the field, type a field name, and select 'Memo' from the drop-down list in the 'Data Type' column.
1) If the Database window is not active, activate the Database window.
2) Open the table's Design view.
3) Do one of the following to add a field to the table:
a) To add the field to the end of the table, click in the first blank row.
b) To insert a field within the table:
1] Click in the row above which the field is to be added.
2] Select the 'Insert' menu and select 'Field'. (The row appears above the selected row.)
4) Type a name for the field in the 'Field Name' column.
5) Click in the 'Data Type' column. (A down arrow appears.)
6) Click on the arrow in the 'Data Type' column. (A drop-down list appears.)
7) Select 'Memo' from the 'Data Type' drop-down list.
Memo
8) (Optional) Set field properties for the added field:
a) Move to the 'Field Properties' section.
Field Properties section
b) Click the 'General' tab.
c) Make the desired entries and selections.
9) Select the 'File' menu and select 'Save'.
10) Select the 'File' menu and select 'Close' when finished making changes in the Table Design window.
